UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPNEVnutGqGMsJdBS8+3b3DkCMA7c0bfJH23hjebIOU='
WHERE
key_id = '87da32a56438f777aa48e6a9ad3ea5f165987bf7c1bbe206d4c151e0a195cd7d'
AND (
token = 'zPNEVnutGqGMsJdBS8+3b3DkCMA7c0bfJH23hjebIOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)