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