UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nBxVshap+v3e6Ue2HwBAqcwXrNKy1hYfjm8mGxCIBQ4='
WHERE
key_id = '1837f5337e0c1064c547940b213cd3d07cdca4c18ecc7e93dfeddde5a9eb264a'
AND (
token = 'nBxVshap+v3e6Ue2HwBAqcwXrNKy1hYfjm8mGxCIBQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)