UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4OsY+hCLe6osmVYhDlcwmwH2IpzczrOFHOOWdaUFrew='
WHERE
key_id = 'aae7bc4e72a6441303d0e627123a32801cb2df7b9f769f69d386f64f40ae8dfd'
AND (
token = '4OsY+hCLe6osmVYhDlcwmwH2IpzczrOFHOOWdaUFrew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)