UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wYWZLAvKAlJzBaUaPZdjqEqFv4N+OBAid85hbAIxHmw='
WHERE
key_id = '687b6270482e506c498c94c79b061a7513a15168a9f0d6edf8db845771be78a9'
AND (
token = 'wYWZLAvKAlJzBaUaPZdjqEqFv4N+OBAid85hbAIxHmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)