UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CscPYMBNEVDAURZdQktpf+ceOVUO9+/E9Clfh8VcNHA='
WHERE
key_id = 'd6a3db8e348171721a352ff04f36fee3e8846e1807e55447662410c97f532bd8'
AND (
token = 'CscPYMBNEVDAURZdQktpf+ceOVUO9+/E9Clfh8VcNHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)