UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUim0WXTFD3CldW+iTmOSeYJ0KT37yq6QA+iRyT2aIY='
WHERE
key_id = '8c12cfc782a21557323847dc8386ae37e232c12dcbbc267a0ef61e9d6ee490c9'
AND (
token = 'hUim0WXTFD3CldW+iTmOSeYJ0KT37yq6QA+iRyT2aIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)