UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wS9WepT8+4Tv83QywpJ3vIpb/2kbq7Dpa+YB47+xxFo='
WHERE
key_id = '5bbbf91cc644c2f15c9070e6e32f5631c4292ac3b3f5299fbd4fa2fa07ca5e2d'
AND (
token = 'wS9WepT8+4Tv83QywpJ3vIpb/2kbq7Dpa+YB47+xxFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)