UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7GHh2SyLmqbHPThy12FCVkodT8q1JOQask1sUyE0hg='
WHERE
key_id = '46174eb252ecc4798e31f63e2e2eed8c7abb74a0ef087cad91b92060abf19926'
AND (
token = 'a7GHh2SyLmqbHPThy12FCVkodT8q1JOQask1sUyE0hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)