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