UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZGfosT+1lWffPEn8JvKR72t4dX076qH/8cHwXxDurk='
WHERE
key_id = '1ccd58a56d86fe1226be6e6ec691eb71bf3df650edae1bf08daff5377241554d'
AND (
token = 'qZGfosT+1lWffPEn8JvKR72t4dX076qH/8cHwXxDurk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)