UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgGV5kT//cMN7m3Mv4DK6M2cJk0lPpTCUwVDNo7BDJo='
WHERE
key_id = 'e17f6f68cd250e7070a0a06fe3ea93806e793c0766f67b44c1ef9838be477ebb'
AND (
token = 'XgGV5kT//cMN7m3Mv4DK6M2cJk0lPpTCUwVDNo7BDJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)