UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MyPRtGyDhGB8eSRLbZIaGhy1RVrhh6kPqq9HRPygYB0='
WHERE
key_id = 'a2d6c6d23df0c5d1c5bac1a531f28a0f2fa7eac8f318f58b46060f3c76a8cd0b'
AND (
token = 'MyPRtGyDhGB8eSRLbZIaGhy1RVrhh6kPqq9HRPygYB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)