UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2GUU1CL0uU0atq57I5VFIVoAkXE5coNDlEoLM9S9yj0='
WHERE
key_id = '0cd700bc9ef5c6a1281b3027eb11c18b8a1e732bf647b9441f4e78a61e206a18'
AND (
token = '2GUU1CL0uU0atq57I5VFIVoAkXE5coNDlEoLM9S9yj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)