UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIvBYea6TatHb/SswiN8i3ypeQg1V63cQmizWyqB0j0='
WHERE
key_id = '6848fd6bcb480e47adfc8ea7b4b83c2f4f623cc27b71d92fdbc44a30707fa30d'
AND (
token = 'XIvBYea6TatHb/SswiN8i3ypeQg1V63cQmizWyqB0j0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)