UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xX4aqavvpA7GdiuoMp1boQKFvDe7BtEMiPL4sbzKr7c='
WHERE
key_id = 'cdda47335ac4e641cec4f05441afc7a09d0ad7c9b76c672a0603d691961c863b'
AND (
token = 'xX4aqavvpA7GdiuoMp1boQKFvDe7BtEMiPL4sbzKr7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)