UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cJrWI27v743fcCfPgwg+jH67CoR1AxM0GcfW+f9JXLg='
WHERE
key_id = '1e475dc5052478b85da1d920d4a0fc3ec4414f4d6dd38e7c0111defbcdab6ec2'
AND (
token = 'cJrWI27v743fcCfPgwg+jH67CoR1AxM0GcfW+f9JXLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)