UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXgABk0zlc+p7qcAMpGdZlIjz56F32Kv4m+H8noly6o='
WHERE
key_id = '7ab9133d0ca359d01b05f0cb0c46598706367fbccb23aedc3d4b07d45d956745'
AND (
token = 'fXgABk0zlc+p7qcAMpGdZlIjz56F32Kv4m+H8noly6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)