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