UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xUyplFIaSYX1Eh/8kMHRoXdImL3MYXrwIUJp3j7kANs='
WHERE
key_id = 'ab747fbb18a74f7224a4738efa07e4792f4d49cba62ccab10492cf5ba2085cdb'
AND (
token = 'xUyplFIaSYX1Eh/8kMHRoXdImL3MYXrwIUJp3j7kANs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)