UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8PgLAgxXCpGGUuoZ1FCJFYaAmR7tvci99+pwT9ku5jw='
WHERE
key_id = '14036675a89b83064b1e0e661c4ae83cb28a41f234e6b986fc1744170dcc5478'
AND (
token = '8PgLAgxXCpGGUuoZ1FCJFYaAmR7tvci99+pwT9ku5jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)