UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SDuMByBKRWPF9Yb5Q6eQi8e2GwIFnDfN1qUHs0oFcKg='
WHERE
key_id = 'c4786267142e21212e6f93ed37447705000ed82e3849982568473eab43565dea'
AND (
token = 'SDuMByBKRWPF9Yb5Q6eQi8e2GwIFnDfN1qUHs0oFcKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)