UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTx+sALq7JmUpLrRZ9KNzo5W1SeLQTY4WRurw4m8weM='
WHERE
key_id = 'efbb0c389dcce088632f71b215a3a846e021216b0ece7b50e2ba07b4fe02b8ab'
AND (
token = 'ZTx+sALq7JmUpLrRZ9KNzo5W1SeLQTY4WRurw4m8weM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)