UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u1n3wAWmFwdIIJ8O8CVnTE1pw9kL757luhaVnKVunmU='
WHERE
key_id = '97505de6a991c9b7ed053b9006c13b3d8a1cf636b4d9515e714031aa5c795da8'
AND (
token = 'u1n3wAWmFwdIIJ8O8CVnTE1pw9kL757luhaVnKVunmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)