UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX0KL79vftKekQGqcI/IbRGfoz4e5dw8imD2qkAiDTQ='
WHERE
key_id = 'cd4fba6bf187f5c003eced19b2d00a83cde82314c8504ff921f8ab93ad428b8a'
AND (
token = 'gX0KL79vftKekQGqcI/IbRGfoz4e5dw8imD2qkAiDTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)