UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lqRihX4bxlqYkaGuZ8yaaLtB8CmPd205J8ZYD964E6E='
WHERE
key_id = '0e74b6ee7e158a1e4a301652aad465b870e7a2412477974c3b2fac3b5815d307'
AND (
token = 'lqRihX4bxlqYkaGuZ8yaaLtB8CmPd205J8ZYD964E6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)