UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jI9i5BMHkULrqFE6HiC4l8ssXqLxesDmzkz3Ue2IhWk='
WHERE
key_id = '74fcdb849055b7c728ae1018a3ddbbe2cdc05be7de2fad3010cacca99ccd37f8'
AND (
token = 'jI9i5BMHkULrqFE6HiC4l8ssXqLxesDmzkz3Ue2IhWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)