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