UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YuXErfnU0FafyUNQMsC8B8d4it+eSQYcsqVtTM0aNQw='
WHERE
key_id = 'd46e52f1ffdbce529cf195d0a4beeae792c9f98a2f0f7fae17056d74c00a3d44'
AND (
token = 'YuXErfnU0FafyUNQMsC8B8d4it+eSQYcsqVtTM0aNQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)