UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnchiMCNw6UbGVc7vBGffz7ZcZy34nW2c6ZJ8D7or+M='
WHERE
key_id = '2aca0e91166772657349418c996e782fbe6531597b8fd8d31832f11fad4b2077'
AND (
token = 'ZnchiMCNw6UbGVc7vBGffz7ZcZy34nW2c6ZJ8D7or+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)