UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MklbhFyBeVKQnm1YX+r0Xmw3RvYiv141i2IO8mJTtoc='
WHERE
key_id = 'c88418089ff68cca091eef8de94b52165fe6824e2b13cc210d97077e5065e170'
AND (
token = 'MklbhFyBeVKQnm1YX+r0Xmw3RvYiv141i2IO8mJTtoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)