UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ClRoJi4ayx95sHJvBUXeuTVk7YeG7khMvz+55KADmbk='
WHERE
key_id = '5f9d4c0cea8f5f342a7dd53ce5d7fa99c8c301c9bac6cd7dbaf49a5fed4d4029'
AND (
token = 'ClRoJi4ayx95sHJvBUXeuTVk7YeG7khMvz+55KADmbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)