UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'keEw65440uJh4lNxMHJ3j92YUSX6EXRUy1atJl0x+zc='
WHERE
key_id = '530fddb2903d0920a204c7e06c29f0bc4b33f387abe512579f4422750833bc20'
AND (
token = 'keEw65440uJh4lNxMHJ3j92YUSX6EXRUy1atJl0x+zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)