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