UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVK9BhZmwTGYsW1YXzC52F3ErUnJTaIbmN5zsAaOvXk='
WHERE
key_id = '0fd0b5d21f73f6b447839dcfdcbb2bb9b60a033643967e631fe9f92b3101da74'
AND (
token = 'vVK9BhZmwTGYsW1YXzC52F3ErUnJTaIbmN5zsAaOvXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)